-- vmModel.Host
CREATE TABLE [Hosts] (
    [version] varchar(60) NOT NULL,         -- _version
    [username] varchar(32) NOT NULL,        -- _username
    [password] varchar(64) NOT NULL,        -- _password
    [ipv6] varchar(40) NOT NULL,            -- _ipv6
    [ipv4] varchar(16) NOT NULL,            -- _ipv4
    [hostid] bigint IDENTITY NOT NULL,      -- _hostid
    CONSTRAINT [pk_Hosts] PRIMARY KEY ([hostid])
)
go

-- vmModel.VM
CREATE TABLE [VMs] (
    [uuid] varchar(36) NOT NULL,            -- _uuid
    [memorys] bigint NOT NULL,              -- _memorys
    [hostid] bigint NULL,                   -- _hostid
    [descr] varchar(100) NOT NULL,          -- _descr
    [cpus] int NOT NULL,                    -- _cpus
    CONSTRAINT [pk_VMs] PRIMARY KEY ([uuid])
)
go

